﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 第三方信息实体类：fanli_userAddon 。
	/// </summary>
	[Serializable]
	public class fanli_userAddon
	{
		public fanli_userAddon()
		{}

		#region Model
		private int _id; //id
		private string _siteName; //第三方名称
		private string _username; //用户名
		private int _userid; //会员id
		private DateTime? _logintime; //登录时间
		private string _loginip; //登录ip
		private int _loginnum; //登录次数
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 第三方名称
		/// </summary>
		public string siteName
		{
			set{ _siteName=value;}
			get{return _siteName;}
		}
        /// <summary>
		/// 用户名
		/// </summary>
		public string username
		{
			set{ _username=value;}
			get{return _username;}
		}
        /// <summary>
		/// 会员id
		/// </summary>
		public int userid
		{
			set{ _userid=value;}
			get{return _userid;}
		}
        /// <summary>
		/// 登录时间
		/// </summary>
		public DateTime? logintime
		{
			set{ _logintime=value;}
			get{return _logintime;}
		}
        /// <summary>
		/// 登录ip
		/// </summary>
		public string loginip
		{
			set{ _loginip=value;}
			get{return _loginip;}
		}
        /// <summary>
		/// 登录次数
		/// </summary>
		public int loginnum
		{
			set{ _loginnum=value;}
			get{return _loginnum;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
第三方信息,userAddon
id,第三方名称,用户名,会员id,登录时间,登录ip,登录次数,扩展1,扩展2
id,siteName,username,userid,logintime,loginip,loginnum,ext1,ext2
i,c20,c100,i,d,c20,i,c100,c100

--------------------------
-- 创建表[第三方信息]开始: 
-- alter table  [fanli_userAddon] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_userAddon') drop table fanli_userAddon
  CREATE TABLE [fanli_userAddon] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [siteName] [varchar] (20),
	 [username] [varchar] (100),
	 [userid] int,
	 [logintime] [datetime],
	 [loginip] [varchar] (20),
	 [loginnum] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'第三方信息 ',N'user',N'dbo',N'table',N'fanli_userAddon', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'第三方名称',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'siteName'
 exec sp_addextendedproperty N'MS_Description',N'用户名',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'username'
 exec sp_addextendedproperty N'MS_Description',N'会员id',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'userid'
 exec sp_addextendedproperty N'MS_Description',N'登录时间',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'logintime'
 exec sp_addextendedproperty N'MS_Description',N'登录ip',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'loginip'
 exec sp_addextendedproperty N'MS_Description',N'登录次数',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'loginnum'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_userAddon',N'column',N'ext2'

-- 创建表[第三方信息]结束。 
--------------------------

		*/
		#endregion document
	}
}

